Overview

Dataset statistics

Number of variables18
Number of observations1100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory147.3 KiB
Average record size in memory137.1 B

Variable types

Categorical5
Boolean1
Numeric12

Alerts

id has a high cardinality: 1047 distinct valuesHigh cardinality
name has a high cardinality: 1017 distinct valuesHigh cardinality
artists has a high cardinality: 687 distinct valuesHigh cardinality
artistid has a high cardinality: 429 distinct valuesHigh cardinality
genres has a high cardinality: 374 distinct valuesHigh cardinality
energy is highly overall correlated with loudnessHigh correlation
loudness is highly overall correlated with energyHigh correlation
id is uniformly distributedUniform
name is uniformly distributedUniform
instrumentalness has 599 (54.5%) zerosZeros

Reproduction

Analysis started2023-02-05 19:22:17.681821
Analysis finished2023-02-05 19:22:41.514141
Duration23.83 seconds
Software versionydata-profiling vv4.0.0
Download configurationconfig.json

Variables

id
Categorical

HIGH CARDINALITY  UNIFORM 

Distinct1047
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Memory size8.7 KiB
3w3y8KPTfNeOKPiqUTakBh
 
2
7lGKEWMXVWWTt3X71Bv44I
 
2
5masKPHeAOVNgxdLebIcK7
 
2
7GgWAITsYJaRM3r50rfh5w
 
2
6Knv6wdA0luoMUuuoYi2i1
 
2
Other values (1042)
1090 

Length

Max length22
Median length22
Mean length22
Min length22

Characters and Unicode

Total characters24200
Distinct characters62
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique994 ?
Unique (%)90.4%

Sample

1st row3w3y8KPTfNeOKPiqUTakBh
2nd row3TGRqZ0a2l1LRblBkJoaDx
3rd row7a86XRg84qjasly9f6bPSD
4th row1z9kQ14XBSN0r2v6fx4IdG
5th row3GZD6HmiNUhxXYf8Gch723

Common Values

ValueCountFrequency (%)
3w3y8KPTfNeOKPiqUTakBh 2
 
0.2%
7lGKEWMXVWWTt3X71Bv44I 2
 
0.2%
5masKPHeAOVNgxdLebIcK7 2
 
0.2%
7GgWAITsYJaRM3r50rfh5w 2
 
0.2%
6Knv6wdA0luoMUuuoYi2i1 2
 
0.2%
0fYVliAYKHuPmECRs1pbRf 2
 
0.2%
5uDASfU19gDxSjW8cnCaBp 2
 
0.2%
7dt6x5M1jzdTEt8oCbisTK 2
 
0.2%
6HZ9VeI5IRFCNQLXhpF4bq 2
 
0.2%
6cx06DFPPHchuUAcTxznu9 2
 
0.2%
Other values (1037) 1080
98.2%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
3w3y8kptfneokpiqutakbh 2
 
0.2%
6uellqglwmcvh1e5c4h7ly 2
 
0.2%
6wri0lac5m1rw2mnx2zveg 2
 
0.2%
6g6a7qnhtfugosh7rooxtd 2
 
0.2%
0e8nrvls4qqv5rfa2uhqmo 2
 
0.2%
6uj1ctrbojoas8xzxgqkk4 2
 
0.2%
6taqoooxaecijl6g1aws2k 2
 
0.2%
27gmp9awrs744szkcpjstz 2
 
0.2%
62pasfnxsmylshyjrltul3 2
 
0.2%
54bfm56pme4ylrnqpw6tha 2
 
0.2%
Other values (1037) 1080
98.2%

Most occurring characters

ValueCountFrequency (%)
6 541
 
2.2%
0 539
 
2.2%
4 532
 
2.2%
2 527
 
2.2%
3 522
 
2.2%
1 516
 
2.1%
5 487
 
2.0%
7 477
 
2.0%
R 416
 
1.7%
A 411
 
1.7%
Other values (52) 19232
79.5%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 9702
40.1%
Lowercase Letter 9635
39.8%
Decimal Number 4863
20.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
R 416
 
4.3%
A 411
 
4.2%
O 404
 
4.2%
L 400
 
4.1%
I 399
 
4.1%
K 397
 
4.1%
Z 391
 
4.0%
X 381
 
3.9%
V 376
 
3.9%
M 374
 
3.9%
Other values (16) 5753
59.3%
Lowercase Letter
ValueCountFrequency (%)
t 398
 
4.1%
l 398
 
4.1%
i 397
 
4.1%
w 396
 
4.1%
h 395
 
4.1%
b 393
 
4.1%
k 383
 
4.0%
s 382
 
4.0%
u 380
 
3.9%
c 378
 
3.9%
Other values (16) 5735
59.5%
Decimal Number
ValueCountFrequency (%)
6 541
11.1%
0 539
11.1%
4 532
10.9%
2 527
10.8%
3 522
10.7%
1 516
10.6%
5 487
10.0%
7 477
9.8%
9 370
7.6%
8 352
7.2%

Most occurring scripts

ValueCountFrequency (%)
Latin 19337
79.9%
Common 4863
 
20.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
R 416
 
2.2%
A 411
 
2.1%
O 404
 
2.1%
L 400
 
2.1%
I 399
 
2.1%
t 398
 
2.1%
l 398
 
2.1%
K 397
 
2.1%
i 397
 
2.1%
w 396
 
2.0%
Other values (42) 15321
79.2%
Common
ValueCountFrequency (%)
6 541
11.1%
0 539
11.1%
4 532
10.9%
2 527
10.8%
3 522
10.7%
1 516
10.6%
5 487
10.0%
7 477
9.8%
9 370
7.6%
8 352
7.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 24200
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 541
 
2.2%
0 539
 
2.2%
4 532
 
2.2%
2 527
 
2.2%
3 522
 
2.2%
1 516
 
2.1%
5 487
 
2.0%
7 477
 
2.0%
R 416
 
1.7%
A 411
 
1.7%
Other values (52) 19232
79.5%

name
Categorical

HIGH CARDINALITY  UNIFORM 

Distinct1017
Distinct (%)92.5%
Missing0
Missing (%)0.0%
Memory size8.7 KiB
Don't
 
3
Sorry
 
3
Locked out of Heaven
 
2
INDUSTRY BABY (feat. Jack Harlow)
 
2
Heat Waves
 
2
Other values (1012)
1088 

Length

Max length94
Median length58
Mean length17.41
Min length1

Characters and Unicode

Total characters19151
Distinct characters96
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique936 ?
Unique (%)85.1%

Sample

1st rowLocked out of Heaven
2nd rowCall Me Maybe
3rd rowWe Are Young (feat. Janelle Monáe)
4th rowDiamonds
5th rowLost

Common Values

ValueCountFrequency (%)
Don't 3
 
0.3%
Sorry 3
 
0.3%
Locked out of Heaven 2
 
0.2%
INDUSTRY BABY (feat. Jack Harlow) 2
 
0.2%
Heat Waves 2
 
0.2%
Talk Dirty (feat. 2 Chainz) 2
 
0.2%
Ride It 2
 
0.2%
Woman 2
 
0.2%
STAY (with Justin Bieber) 2
 
0.2%
High Hopes 2
 
0.2%
Other values (1007) 1078
98.0%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
feat 178
 
4.9%
105
 
2.9%
the 81
 
2.2%
you 74
 
2.0%
me 62
 
1.7%
with 62
 
1.7%
i 57
 
1.6%
love 56
 
1.5%
it 38
 
1.0%
my 31
 
0.9%
Other values (1424) 2884
79.5%

Most occurring characters

ValueCountFrequency (%)
2528
 
13.2%
e 1698
 
8.9%
a 1219
 
6.4%
o 1097
 
5.7%
t 957
 
5.0%
i 928
 
4.8%
n 810
 
4.2%
r 749
 
3.9%
l 562
 
2.9%
s 527
 
2.8%
Other values (86) 8076
42.2%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 11923
62.3%
Uppercase Letter 3550
 
18.5%
Space Separator 2528
 
13.2%
Other Punctuation 408
 
2.1%
Open Punctuation 276
 
1.4%
Close Punctuation 276
 
1.4%
Decimal Number 103
 
0.5%
Dash Punctuation 64
 
0.3%
Currency Symbol 8
 
< 0.1%
Final Punctuation 6
 
< 0.1%
Other values (2) 9
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 1698
14.2%
a 1219
10.2%
o 1097
 
9.2%
t 957
 
8.0%
i 928
 
7.8%
n 810
 
6.8%
r 749
 
6.3%
l 562
 
4.7%
s 527
 
4.4%
h 442
 
3.7%
Other values (21) 2934
24.6%
Uppercase Letter
ValueCountFrequency (%)
S 297
 
8.4%
T 286
 
8.1%
L 262
 
7.4%
M 220
 
6.2%
B 211
 
5.9%
A 186
 
5.2%
I 181
 
5.1%
D 180
 
5.1%
W 168
 
4.7%
H 155
 
4.4%
Other values (18) 1404
39.5%
Other Punctuation
ValueCountFrequency (%)
. 212
52.0%
' 75
 
18.4%
& 52
 
12.7%
, 29
 
7.1%
" 12
 
2.9%
* 8
 
2.0%
? 6
 
1.5%
: 4
 
1.0%
/ 3
 
0.7%
! 3
 
0.7%
Other values (3) 4
 
1.0%
Decimal Number
ValueCountFrequency (%)
2 24
23.3%
0 18
17.5%
1 16
15.5%
3 12
11.7%
5 11
10.7%
4 6
 
5.8%
7 5
 
4.9%
9 5
 
4.9%
8 3
 
2.9%
6 3
 
2.9%
Other Letter
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%
Open Punctuation
ValueCountFrequency (%)
( 275
99.6%
[ 1
 
0.4%
Close Punctuation
ValueCountFrequency (%)
) 275
99.6%
] 1
 
0.4%
Space Separator
ValueCountFrequency (%)
2528
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%
Currency Symbol
ValueCountFrequency (%)
$ 8
100.0%
Final Punctuation
ValueCountFrequency (%)
6
100.0%
Math Symbol
ValueCountFrequency (%)
+ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 15473
80.8%
Common 3673
 
19.2%
Hangul 5
 
< 0.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 1698
 
11.0%
a 1219
 
7.9%
o 1097
 
7.1%
t 957
 
6.2%
i 928
 
6.0%
n 810
 
5.2%
r 749
 
4.8%
l 562
 
3.6%
s 527
 
3.4%
h 442
 
2.9%
Other values (49) 6484
41.9%
Common
ValueCountFrequency (%)
2528
68.8%
( 275
 
7.5%
) 275
 
7.5%
. 212
 
5.8%
' 75
 
2.0%
- 64
 
1.7%
& 52
 
1.4%
, 29
 
0.8%
2 24
 
0.7%
0 18
 
0.5%
Other values (22) 121
 
3.3%
Hangul
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 19123
99.9%
None 17
 
0.1%
Punctuation 6
 
< 0.1%
Hangul 5
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2528
 
13.2%
e 1698
 
8.9%
a 1219
 
6.4%
o 1097
 
5.7%
t 957
 
5.0%
i 928
 
4.9%
n 810
 
4.2%
r 749
 
3.9%
l 562
 
2.9%
s 527
 
2.8%
Other values (73) 8048
42.1%
Punctuation
ValueCountFrequency (%)
6
100.0%
None
ValueCountFrequency (%)
é 4
23.5%
í 3
17.6%
Á 3
17.6%
á 2
11.8%
ó 2
11.8%
ñ 2
11.8%
Ü 1
 
5.9%
Hangul
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%

artists
Categorical

Distinct687
Distinct (%)62.5%
Missing0
Missing (%)0.0%
Memory size8.7 KiB
['Taylor Swift']
 
23
['Ed Sheeran']
 
15
['Ariana Grande']
 
14
['Drake']
 
14
['Billie Eilish']
 
13
Other values (682)
1021 

Length

Max length131
Median length60
Mean length20.704545
Min length6

Characters and Unicode

Total characters22775
Distinct characters88
Distinct categories10 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique544 ?
Unique (%)49.5%

Sample

1st row['Bruno Mars']
2nd row['Carly Rae Jepsen']
3rd row['fun.', 'Janelle Monáe']
4th row['Rihanna']
5th row['Frank Ocean']

Common Values

ValueCountFrequency (%)
['Taylor Swift'] 23
 
2.1%
['Ed Sheeran'] 15
 
1.4%
['Ariana Grande'] 14
 
1.3%
['Drake'] 14
 
1.3%
['Billie Eilish'] 13
 
1.2%
['Adele'] 12
 
1.1%
['One Direction'] 11
 
1.0%
['The Weeknd'] 11
 
1.0%
['Justin Bieber'] 10
 
0.9%
['Shawn Mendes'] 9
 
0.8%
Other values (677) 968
88.0%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
the 65
 
2.2%
drake 37
 
1.3%
justin 34
 
1.2%
lil 33
 
1.1%
bieber 29
 
1.0%
swift 28
 
1.0%
taylor 28
 
1.0%
grande 28
 
1.0%
ariana 28
 
1.0%
weeknd 23
 
0.8%
Other values (909) 2580
88.6%

Most occurring characters

ValueCountFrequency (%)
' 3281
 
14.4%
1813
 
8.0%
a 1510
 
6.6%
e 1395
 
6.1%
i 1131
 
5.0%
[ 1100
 
4.8%
] 1100
 
4.8%
n 970
 
4.3%
r 896
 
3.9%
o 769
 
3.4%
Other values (78) 8810
38.7%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 11459
50.3%
Other Punctuation 3884
 
17.1%
Uppercase Letter 3325
 
14.6%
Space Separator 1813
 
8.0%
Open Punctuation 1100
 
4.8%
Close Punctuation 1100
 
4.8%
Decimal Number 60
 
0.3%
Dash Punctuation 20
 
0.1%
Currency Symbol 12
 
0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 1510
13.2%
e 1395
12.2%
i 1131
9.9%
n 970
 
8.5%
r 896
 
7.8%
o 769
 
6.7%
l 764
 
6.7%
s 555
 
4.8%
t 424
 
3.7%
h 388
 
3.4%
Other values (22) 2657
23.2%
Uppercase Letter
ValueCountFrequency (%)
S 276
 
8.3%
B 254
 
7.6%
T 237
 
7.1%
M 235
 
7.1%
L 226
 
6.8%
C 220
 
6.6%
D 214
 
6.4%
A 210
 
6.3%
J 169
 
5.1%
R 156
 
4.7%
Other values (21) 1128
33.9%
Decimal Number
ValueCountFrequency (%)
5 16
26.7%
2 13
21.7%
1 9
15.0%
9 6
 
10.0%
6 4
 
6.7%
7 4
 
6.7%
4 4
 
6.7%
3 2
 
3.3%
8 1
 
1.7%
0 1
 
1.7%
Other Punctuation
ValueCountFrequency (%)
' 3281
84.5%
, 543
 
14.0%
. 27
 
0.7%
" 10
 
0.3%
& 9
 
0.2%
! 9
 
0.2%
\ 2
 
0.1%
* 2
 
0.1%
/ 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
1813
100.0%
Open Punctuation
ValueCountFrequency (%)
[ 1100
100.0%
Close Punctuation
ValueCountFrequency (%)
] 1100
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%
Currency Symbol
ValueCountFrequency (%)
$ 12
100.0%
Math Symbol
ValueCountFrequency (%)
+ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 14784
64.9%
Common 7991
35.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
a 1510
 
10.2%
e 1395
 
9.4%
i 1131
 
7.7%
n 970
 
6.6%
r 896
 
6.1%
o 769
 
5.2%
l 764
 
5.2%
s 555
 
3.8%
t 424
 
2.9%
h 388
 
2.6%
Other values (53) 5982
40.5%
Common
ValueCountFrequency (%)
' 3281
41.1%
1813
22.7%
[ 1100
 
13.8%
] 1100
 
13.8%
, 543
 
6.8%
. 27
 
0.3%
- 20
 
0.3%
5 16
 
0.2%
2 13
 
0.2%
$ 12
 
0.2%
Other values (15) 66
 
0.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 22739
99.8%
None 36
 
0.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
' 3281
 
14.4%
1813
 
8.0%
a 1510
 
6.6%
e 1395
 
6.1%
i 1131
 
5.0%
[ 1100
 
4.8%
] 1100
 
4.8%
n 970
 
4.3%
r 896
 
3.9%
o 769
 
3.4%
Other values (67) 8774
38.6%
None
ValueCountFrequency (%)
é 15
41.7%
Ø 4
 
11.1%
ë 4
 
11.1%
Í 3
 
8.3%
á 2
 
5.6%
ó 2
 
5.6%
å 2
 
5.6%
É 1
 
2.8%
Ñ 1
 
2.8%
í 1
 
2.8%

artistid
Categorical

Distinct429
Distinct (%)39.0%
Missing0
Missing (%)0.0%
Memory size8.7 KiB
06HL4z0CvFAxyc27GXpf02
 
26
3TVXtAsR1Inumwj472S9r4
 
26
66CXWjxzNUsdJxJ2JdwvnR
 
23
1uNFoZAHBGtllmzznpCI3s
 
18
7CajNmpbOovFoOoasH2HaY
 
18
Other values (424)
989 

Length

Max length22
Median length22
Mean length22
Min length22

Characters and Unicode

Total characters24200
Distinct characters62
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique250 ?
Unique (%)22.7%

Sample

1st row0du5cEVh5yTK9QJze8zA0C
2nd row6sFIWsNpZYqfjUpaCgueju
3rd row5nCi3BB41mBaMH9gfr6Su0
4th row5pKCCKE2ajJHZ9KAiaK11H
5th row2h93pZq0e7k5yf4dywlkpM

Common Values

ValueCountFrequency (%)
06HL4z0CvFAxyc27GXpf02 26
 
2.4%
3TVXtAsR1Inumwj472S9r4 26
 
2.4%
66CXWjxzNUsdJxJ2JdwvnR 23
 
2.1%
1uNFoZAHBGtllmzznpCI3s 18
 
1.6%
7CajNmpbOovFoOoasH2HaY 18
 
1.6%
6eUKZXaKkcviH0Ku9w2n3V 17
 
1.5%
1Xyo4u8uXC1ZmMpatF05PJ 16
 
1.5%
246dkjvS1zLTtiykXe5h60 16
 
1.5%
6qqNVTkY8uBg9cP3Jd7DAH 15
 
1.4%
7n2wHs1TKAczGzO7Dd2rGr 14
 
1.3%
Other values (419) 911
82.8%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
06hl4z0cvfaxyc27gxpf02 26
 
2.4%
3tvxtasr1inumwj472s9r4 26
 
2.4%
66cxwjxznusdjxj2jdwvnr 23
 
2.1%
1unfozahbgtllmzznpci3s 18
 
1.6%
7cajnmpboovfoooash2hay 18
 
1.6%
6eukzxakkcvih0ku9w2n3v 17
 
1.5%
1xyo4u8uxc1zmmpatf05pj 16
 
1.5%
246dkjvs1zlttiykxe5h60 16
 
1.5%
6qqnvtky8ubg9cp3jd7dah 15
 
1.4%
7n2whs1tkaczgzo7dd2rgr 14
 
1.3%
Other values (419) 911
82.8%

Most occurring characters

ValueCountFrequency (%)
6 678
 
2.8%
4 627
 
2.6%
2 602
 
2.5%
0 571
 
2.4%
7 519
 
2.1%
1 518
 
2.1%
5 512
 
2.1%
H 497
 
2.1%
X 477
 
2.0%
K 451
 
1.9%
Other values (52) 18748
77.5%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 9529
39.4%
Uppercase Letter 9437
39.0%
Decimal Number 5234
21.6%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
H 497
 
5.3%
X 477
 
5.1%
K 451
 
4.8%
C 451
 
4.8%
A 414
 
4.4%
Y 403
 
4.3%
S 392
 
4.2%
N 382
 
4.0%
F 370
 
3.9%
W 366
 
3.9%
Other values (16) 5234
55.5%
Lowercase Letter
ValueCountFrequency (%)
w 434
 
4.6%
j 432
 
4.5%
a 421
 
4.4%
v 419
 
4.4%
o 417
 
4.4%
z 411
 
4.3%
n 408
 
4.3%
s 407
 
4.3%
y 390
 
4.1%
q 384
 
4.0%
Other values (16) 5406
56.7%
Decimal Number
ValueCountFrequency (%)
6 678
13.0%
4 627
12.0%
2 602
11.5%
0 571
10.9%
7 519
9.9%
1 518
9.9%
5 512
9.8%
9 450
8.6%
3 435
8.3%
8 322
6.2%

Most occurring scripts

ValueCountFrequency (%)
Latin 18966
78.4%
Common 5234
 
21.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
H 497
 
2.6%
X 477
 
2.5%
K 451
 
2.4%
C 451
 
2.4%
w 434
 
2.3%
j 432
 
2.3%
a 421
 
2.2%
v 419
 
2.2%
o 417
 
2.2%
A 414
 
2.2%
Other values (42) 14553
76.7%
Common
ValueCountFrequency (%)
6 678
13.0%
4 627
12.0%
2 602
11.5%
0 571
10.9%
7 519
9.9%
1 518
9.9%
5 512
9.8%
9 450
8.6%
3 435
8.3%
8 322
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 24200
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 678
 
2.8%
4 627
 
2.6%
2 602
 
2.5%
0 571
 
2.4%
7 519
 
2.1%
1 518
 
2.1%
5 512
 
2.1%
H 497
 
2.1%
X 477
 
2.0%
K 451
 
1.9%
Other values (52) 18748
77.5%

explicit
Boolean

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
False
736 
True
364 
ValueCountFrequency (%)
False 736
66.9%
True 364
33.1%

popularity
Real number (ℝ)

Distinct61
Distinct (%)5.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean70.113636
Minimum0
Maximum94
Zeros9
Zeros (%)0.8%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum0
5-th percentile57
Q167
median72
Q377
95-th percentile83
Maximum94
Range94
Interquartile range (IQR)10

Descriptive statistics

Standard deviation12.868015
Coefficient of variation (CV)0.18353084
Kurtosis14.294406
Mean70.113636
Median Absolute Deviation (MAD)5
Skewness-3.2482042
Sum77125
Variance165.5858
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
74 70
 
6.4%
71 65
 
5.9%
70 61
 
5.5%
69 59
 
5.4%
75 54
 
4.9%
73 54
 
4.9%
72 52
 
4.7%
66 50
 
4.5%
77 49
 
4.5%
68 45
 
4.1%
Other values (51) 541
49.2%
ValueCountFrequency (%)
0 9
0.8%
2 5
0.5%
4 1
 
0.1%
5 1
 
0.1%
6 2
 
0.2%
8 1
 
0.1%
9 3
 
0.3%
14 1
 
0.1%
15 1
 
0.1%
22 1
 
0.1%
ValueCountFrequency (%)
94 1
 
0.1%
93 2
 
0.2%
92 3
 
0.3%
91 1
 
0.1%
90 3
 
0.3%
89 3
 
0.3%
88 5
 
0.5%
86 4
 
0.4%
85 15
1.4%
84 16
1.5%

durationms
Real number (ℝ)

Distinct1013
Distinct (%)92.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean213461.3
Minimum97392
Maximum613026
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum97392
5-th percentile159340.5
Q1188806
median210577.5
Q3232136.5
95-th percentile281389
Maximum613026
Range515634
Interquartile range (IQR)43330.5

Descriptive statistics

Standard deviation40137.462
Coefficient of variation (CV)0.18803156
Kurtosis11.505154
Mean213461.3
Median Absolute Deviation (MAD)21667.5
Skewness1.7245939
Sum2.3480743 × 108
Variance1.6110159 × 109
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
233478 2
 
0.2%
189486 2
 
0.2%
205879 2
 
0.2%
175238 2
 
0.2%
281560 2
 
0.2%
190185 2
 
0.2%
295502 2
 
0.2%
236133 2
 
0.2%
213427 2
 
0.2%
223078 2
 
0.2%
Other values (1003) 1080
98.2%
ValueCountFrequency (%)
97392 1
0.1%
113000 1
0.1%
114893 1
0.1%
119133 1
0.1%
121886 1
0.1%
122174 1
0.1%
122772 1
0.1%
123262 1
0.1%
126446 1
0.1%
129370 1
0.1%
ValueCountFrequency (%)
613026 1
0.1%
484146 1
0.1%
417920 1
0.1%
354320 1
0.1%
353893 1
0.1%
350120 1
0.1%
347520 1
0.1%
343150 1
0.1%
342040 1
0.1%
340706 1
0.1%

year
Real number (ℝ)

Distinct11
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2017
Minimum2012
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum2012
5-th percentile2012
Q12014
median2017
Q32020
95-th percentile2022
Maximum2022
Range10
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.163716
Coefficient of variation (CV)0.0015685256
Kurtosis-1.2200892
Mean2017
Median Absolute Deviation (MAD)3
Skewness0
Sum2218700
Variance10.009099
MonotonicityIncreasing
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
2012 100
9.1%
2013 100
9.1%
2014 100
9.1%
2015 100
9.1%
2016 100
9.1%
2017 100
9.1%
2018 100
9.1%
2019 100
9.1%
2020 100
9.1%
2021 100
9.1%
ValueCountFrequency (%)
2012 100
9.1%
2013 100
9.1%
2014 100
9.1%
2015 100
9.1%
2016 100
9.1%
2017 100
9.1%
2018 100
9.1%
2019 100
9.1%
2020 100
9.1%
2021 100
9.1%
ValueCountFrequency (%)
2022 100
9.1%
2021 100
9.1%
2020 100
9.1%
2019 100
9.1%
2018 100
9.1%
2017 100
9.1%
2016 100
9.1%
2015 100
9.1%
2014 100
9.1%
2013 100
9.1%

genres
Categorical

Distinct374
Distinct (%)34.0%
Missing0
Missing (%)0.0%
Memory size8.7 KiB
['dance pop', 'pop']
 
63
['pop']
 
60
['pop', 'uk pop']
 
33
['dance pop', 'pop', 'post-teen pop']
 
27
['canadian hip hop', 'canadian pop', 'hip hop', 'rap', 'toronto rap']
 
26
Other values (369)
891 

Length

Max length148
Median length101
Mean length45.266364
Min length2

Characters and Unicode

Total characters49793
Distinct characters34
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique211 ?
Unique (%)19.2%

Sample

1st row['dance pop', 'pop']
2nd row['canadian pop', 'dance pop', 'electropop', 'pop', 'post-teen pop']
3rd row['baroque pop', 'metropopolis', 'modern rock', 'pop rock']
4th row['barbadian pop', 'dance pop', 'pop', 'urban contemporary']
5th row['hip hop', 'lgbtq+ hip hop', 'neo soul', 'pop']

Common Values

ValueCountFrequency (%)
['dance pop', 'pop'] 63
 
5.7%
['pop'] 60
 
5.5%
['pop', 'uk pop'] 33
 
3.0%
['dance pop', 'pop', 'post-teen pop'] 27
 
2.5%
['canadian hip hop', 'canadian pop', 'hip hop', 'rap', 'toronto rap'] 26
 
2.4%
['canadian pop', 'pop'] 18
 
1.6%
['dance pop', 'edm', 'electro house', 'house', 'pop', 'progressive house', 'uk dance'] 18
 
1.6%
['canadian contemporary r&b', 'canadian pop', 'pop'] 16
 
1.5%
['dfw rap', 'melodic rap', 'rap'] 16
 
1.5%
['art pop', 'electropop', 'pop'] 15
 
1.4%
Other values (364) 808
73.5%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
pop 1965
28.7%
dance 577
 
8.4%
rap 503
 
7.3%
hip 338
 
4.9%
hop 319
 
4.7%
house 209
 
3.0%
rock 173
 
2.5%
edm 162
 
2.4%
canadian 135
 
2.0%
uk 126
 
1.8%
Other values (225) 2347
34.2%

Most occurring characters

ValueCountFrequency (%)
' 7962
16.0%
p 6002
12.1%
5754
11.6%
o 4419
 
8.9%
, 2886
 
5.8%
a 2620
 
5.3%
e 2493
 
5.0%
r 2069
 
4.2%
n 1966
 
3.9%
c 1472
 
3.0%
Other values (24) 12150
24.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 30702
61.7%
Other Punctuation 10934
 
22.0%
Space Separator 5754
 
11.6%
Open Punctuation 1100
 
2.2%
Close Punctuation 1100
 
2.2%
Dash Punctuation 187
 
0.4%
Math Symbol 16
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
p 6002
19.5%
o 4419
14.4%
a 2620
8.5%
e 2493
8.1%
r 2069
 
6.7%
n 1966
 
6.4%
c 1472
 
4.8%
t 1421
 
4.6%
i 1335
 
4.3%
d 1234
 
4.0%
Other values (16) 5671
18.5%
Other Punctuation
ValueCountFrequency (%)
' 7962
72.8%
, 2886
 
26.4%
& 86
 
0.8%
Space Separator
ValueCountFrequency (%)
5754
100.0%
Open Punctuation
ValueCountFrequency (%)
[ 1100
100.0%
Close Punctuation
ValueCountFrequency (%)
] 1100
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 187
100.0%
Math Symbol
ValueCountFrequency (%)
+ 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 30702
61.7%
Common 19091
38.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
p 6002
19.5%
o 4419
14.4%
a 2620
8.5%
e 2493
8.1%
r 2069
 
6.7%
n 1966
 
6.4%
c 1472
 
4.8%
t 1421
 
4.6%
i 1335
 
4.3%
d 1234
 
4.0%
Other values (16) 5671
18.5%
Common
ValueCountFrequency (%)
' 7962
41.7%
5754
30.1%
, 2886
 
15.1%
[ 1100
 
5.8%
] 1100
 
5.8%
- 187
 
1.0%
& 86
 
0.5%
+ 16
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 49793
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
' 7962
16.0%
p 6002
12.1%
5754
11.6%
o 4419
 
8.9%
, 2886
 
5.8%
a 2620
 
5.3%
e 2493
 
5.0%
r 2069
 
4.2%
n 1966
 
3.9%
c 1472
 
3.0%
Other values (24) 12150
24.4%

danceability
Real number (ℝ)

Distinct445
Distinct (%)40.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.67377455
Minimum0.188
Maximum0.965
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum0.188
5-th percentile0.4199
Q10.591
median0.687
Q30.77225
95-th percentile0.88115
Maximum0.965
Range0.777
Interquartile range (IQR)0.18125

Descriptive statistics

Standard deviation0.13428767
Coefficient of variation (CV)0.19930653
Kurtosis0.018081853
Mean0.67377455
Median Absolute Deviation (MAD)0.0895
Skewness-0.46708128
Sum741.152
Variance0.018033178
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.664 9
 
0.8%
0.65 8
 
0.7%
0.687 8
 
0.7%
0.781 8
 
0.7%
0.681 8
 
0.7%
0.654 8
 
0.7%
0.688 7
 
0.6%
0.647 7
 
0.6%
0.672 7
 
0.6%
0.794 7
 
0.6%
Other values (435) 1023
93.0%
ValueCountFrequency (%)
0.188 1
0.1%
0.247 1
0.1%
0.259 1
0.1%
0.262 1
0.1%
0.279 1
0.1%
0.308 1
0.1%
0.311 1
0.1%
0.319 1
0.1%
0.322 1
0.1%
0.332 2
0.2%
ValueCountFrequency (%)
0.965 1
 
0.1%
0.964 1
 
0.1%
0.963 1
 
0.1%
0.95 2
0.2%
0.94 1
 
0.1%
0.937 1
 
0.1%
0.935 1
 
0.1%
0.931 1
 
0.1%
0.928 1
 
0.1%
0.926 3
0.3%

acousticness
Real number (ℝ)

Distinct761
Distinct (%)69.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.18329808
Minimum1.29 × 10-5
Maximum0.978
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum1.29 × 10-5
5-th percentile0.0024405
Q10.02225
median0.0892
Q30.25825
95-th percentile0.695
Maximum0.978
Range0.9779871
Interquartile range (IQR)0.236

Descriptive statistics

Standard deviation0.22285452
Coefficient of variation (CV)1.2158039
Kurtosis1.9558303
Mean0.18329808
Median Absolute Deviation (MAD)0.079655
Skewness1.6166711
Sum201.62788
Variance0.049664138
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.174 7
 
0.6%
0.0215 6
 
0.5%
0.223 6
 
0.5%
0.109 5
 
0.5%
0.167 5
 
0.5%
0.127 5
 
0.5%
0.107 5
 
0.5%
0.328 5
 
0.5%
0.17 4
 
0.4%
0.117 4
 
0.4%
Other values (751) 1048
95.3%
ValueCountFrequency (%)
1.29 × 10-51
0.1%
0.000107 1
0.1%
0.00013 1
0.1%
0.000132 1
0.1%
0.000145 1
0.1%
0.000176 1
0.1%
0.000185 1
0.1%
0.000238 1
0.1%
0.000239 1
0.1%
0.000254 1
0.1%
ValueCountFrequency (%)
0.978 1
0.1%
0.965 1
0.1%
0.946 1
0.1%
0.945 1
0.1%
0.937 1
0.1%
0.934 2
0.2%
0.932 2
0.2%
0.924 1
0.1%
0.922 1
0.1%
0.92 1
0.1%

energy
Real number (ℝ)

Distinct500
Distinct (%)45.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.65562582
Minimum0.0519
Maximum0.972
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum0.0519
5-th percentile0.356
Q10.548
median0.673
Q30.783
95-th percentile0.88905
Maximum0.972
Range0.9201
Interquartile range (IQR)0.235

Descriptive statistics

Standard deviation0.16319921
Coefficient of variation (CV)0.24892126
Kurtosis0.077152905
Mean0.65562582
Median Absolute Deviation (MAD)0.115
Skewness-0.54695995
Sum721.1884
Variance0.026633981
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.585 8
 
0.7%
0.795 7
 
0.6%
0.628 7
 
0.6%
0.725 7
 
0.6%
0.655 6
 
0.5%
0.731 6
 
0.5%
0.702 6
 
0.5%
0.7 6
 
0.5%
0.764 6
 
0.5%
0.578 6
 
0.5%
Other values (490) 1035
94.1%
ValueCountFrequency (%)
0.0519 1
0.1%
0.0565 1
0.1%
0.111 1
0.1%
0.133 1
0.1%
0.136 1
0.1%
0.147 1
0.1%
0.153 1
0.1%
0.174 1
0.1%
0.22 1
0.1%
0.225 2
0.2%
ValueCountFrequency (%)
0.972 2
0.2%
0.965 1
 
0.1%
0.963 1
 
0.1%
0.958 1
 
0.1%
0.953 1
 
0.1%
0.951 1
 
0.1%
0.948 1
 
0.1%
0.947 3
0.3%
0.94 1
 
0.1%
0.939 1
 
0.1%

instrumentalness
Real number (ℝ)

Distinct433
Distinct (%)39.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0088869314
Minimum0
Maximum0.896
Zeros599
Zeros (%)54.5%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q34.23 × 10-5
95-th percentile0.0077185
Maximum0.896
Range0.896
Interquartile range (IQR)4.23 × 10-5

Descriptive statistics

Standard deviation0.064897601
Coefficient of variation (CV)7.3025882
Kurtosis113.5069
Mean0.0088869314
Median Absolute Deviation (MAD)0
Skewness10.206228
Sum9.7756246
Variance0.0042116986
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 599
54.5%
6.12 × 10-54
 
0.4%
0.13 4
 
0.4%
0.00106 3
 
0.3%
1.03 × 10-63
 
0.3%
0.000193 3
 
0.3%
1.56 × 10-53
 
0.3%
1.14 × 10-53
 
0.3%
4.82 × 10-62
 
0.2%
1.81 × 10-62
 
0.2%
Other values (423) 474
43.1%
ValueCountFrequency (%)
0 599
54.5%
1.02 × 10-61
 
0.1%
1.03 × 10-63
 
0.3%
1.07 × 10-61
 
0.1%
1.13 × 10-61
 
0.1%
1.18 × 10-62
 
0.2%
1.21 × 10-62
 
0.2%
1.22 × 10-61
 
0.1%
1.26 × 10-61
 
0.1%
1.31 × 10-61
 
0.1%
ValueCountFrequency (%)
0.896 1
0.1%
0.828 1
0.1%
0.809 1
0.1%
0.72 1
0.1%
0.657 1
0.1%
0.621 1
0.1%
0.615 1
0.1%
0.445 1
0.1%
0.352 1
0.1%
0.334 1
0.1%

liveness
Real number (ℝ)

Distinct529
Distinct (%)48.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.16817191
Minimum0.021
Maximum0.979
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum0.021
5-th percentile0.056985
Q10.09235
median0.117
Q30.204
95-th percentile0.3963
Maximum0.979
Range0.958
Interquartile range (IQR)0.11165

Descriptive statistics

Standard deviation0.12568783
Coefficient of variation (CV)0.7473771
Kurtosis6.157514
Mean0.16817191
Median Absolute Deviation (MAD)0.036
Skewness2.1890412
Sum184.9891
Variance0.015797432
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.11 17
 
1.5%
0.109 14
 
1.3%
0.111 14
 
1.3%
0.106 14
 
1.3%
0.105 14
 
1.3%
0.104 13
 
1.2%
0.101 12
 
1.1%
0.117 12
 
1.1%
0.108 11
 
1.0%
0.115 11
 
1.0%
Other values (519) 968
88.0%
ValueCountFrequency (%)
0.021 2
0.2%
0.0215 1
0.1%
0.0241 1
0.1%
0.0264 1
0.1%
0.0283 1
0.1%
0.0335 2
0.2%
0.0344 1
0.1%
0.0371 1
0.1%
0.0383 1
0.1%
0.0411 1
0.1%
ValueCountFrequency (%)
0.979 1
0.1%
0.817 1
0.1%
0.795 1
0.1%
0.792 1
0.1%
0.79 1
0.1%
0.742 1
0.1%
0.737 1
0.1%
0.696 1
0.1%
0.694 1
0.1%
0.689 1
0.1%

loudness
Real number (ℝ)

Distinct966
Distinct (%)87.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-6.0159536
Minimum-21.107
Maximum-1.702
Zeros0
Zeros (%)0.0%
Negative1100
Negative (%)100.0%
Memory size8.7 KiB

Quantile statistics

Minimum-21.107
5-th percentile-9.9995
Q1-7.088
median-5.695
Q3-4.57125
95-th percentile-3.15735
Maximum-1.702
Range19.405
Interquartile range (IQR)2.51675

Descriptive statistics

Standard deviation2.1061531
Coefficient of variation (CV)-0.35009464
Kurtosis3.5403063
Mean-6.0159536
Median Absolute Deviation (MAD)1.271
Skewness-1.2352409
Sum-6617.549
Variance4.435881
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-4.1 3
 
0.3%
-7.079 3
 
0.3%
-7.321 3
 
0.3%
-6.476 3
 
0.3%
-2.671 3
 
0.3%
-6.003 3
 
0.3%
-4.792 3
 
0.3%
-5.797 3
 
0.3%
-4.175 3
 
0.3%
-6.257 2
 
0.2%
Other values (956) 1071
97.4%
ValueCountFrequency (%)
-21.107 1
0.1%
-15.159 1
0.1%
-15.099 1
0.1%
-14.505 1
0.1%
-14.454 1
0.1%
-14.084 1
0.1%
-14.007 1
0.1%
-13.481 1
0.1%
-13.4 1
0.1%
-12.92 1
0.1%
ValueCountFrequency (%)
-1.702 1
0.1%
-2.16 1
0.1%
-2.253 1
0.1%
-2.302 1
0.1%
-2.308 1
0.1%
-2.384 1
0.1%
-2.392 1
0.1%
-2.457 1
0.1%
-2.494 1
0.1%
-2.569 1
0.1%

speechiness
Real number (ℝ)

Distinct625
Distinct (%)56.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.099043909
Minimum0.0232
Maximum0.53
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum0.0232
5-th percentile0.030295
Q10.0413
median0.05895
Q30.107
95-th percentile0.3091
Maximum0.53
Range0.5068
Interquartile range (IQR)0.0657

Descriptive statistics

Standard deviation0.093070082
Coefficient of variation (CV)0.93968506
Kurtosis3.9041154
Mean0.099043909
Median Absolute Deviation (MAD)0.02435
Skewness2.047528
Sum108.9483
Variance0.0086620402
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0432 6
 
0.5%
0.0333 6
 
0.5%
0.0457 6
 
0.5%
0.0304 6
 
0.5%
0.0483 5
 
0.5%
0.0544 5
 
0.5%
0.0355 5
 
0.5%
0.0506 5
 
0.5%
0.0346 5
 
0.5%
0.0363 5
 
0.5%
Other values (615) 1046
95.1%
ValueCountFrequency (%)
0.0232 1
0.1%
0.0253 1
0.1%
0.0259 1
0.1%
0.0262 2
0.2%
0.0265 1
0.1%
0.0267 2
0.2%
0.0268 1
0.1%
0.0269 1
0.1%
0.027 1
0.1%
0.0274 1
0.1%
ValueCountFrequency (%)
0.53 1
0.1%
0.516 1
0.1%
0.505 1
0.1%
0.487 1
0.1%
0.485 1
0.1%
0.467 2
0.2%
0.463 1
0.1%
0.461 1
0.1%
0.449 1
0.1%
0.438 2
0.2%

tempo
Real number (ℝ)

Distinct1001
Distinct (%)91.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean120.05862
Minimum64.934
Maximum205.863
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum64.934
5-th percentile80.02455
Q199.71075
median119.976
Q3135.00325
95-th percentile171.9933
Maximum205.863
Range140.929
Interquartile range (IQR)35.2925

Descriptive statistics

Standard deviation27.12912
Coefficient of variation (CV)0.22596561
Kurtosis0.019119276
Mean120.05862
Median Absolute Deviation (MAD)19.9565
Skewness0.58618246
Sum132064.49
Variance735.98913
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.961 3
 
0.3%
102.977 3
 
0.3%
94.997 3
 
0.3%
104.988 3
 
0.3%
143.994 2
 
0.2%
127.99 2
 
0.2%
109.978 2
 
0.2%
160.015 2
 
0.2%
94.009 2
 
0.2%
123.013 2
 
0.2%
Other values (991) 1076
97.8%
ValueCountFrequency (%)
64.934 1
0.1%
67.016 1
0.1%
68.534 1
0.1%
68.976 1
0.1%
71.912 1
0.1%
71.944 1
0.1%
72.795 1
0.1%
74.132 1
0.1%
74.897 1
0.1%
74.989 1
0.1%
ValueCountFrequency (%)
205.863 1
0.1%
205.846 1
0.1%
202.015 1
0.1%
201.8 1
0.1%
199.811 1
0.1%
198.075 1
0.1%
196.093 2
0.2%
194.169 1
0.1%
192.205 1
0.1%
191.944 1
0.1%

valence
Real number (ℝ)

Distinct619
Distinct (%)56.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.49584009
Minimum0.0381
Maximum0.972
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB

Quantile statistics

Minimum0.0381
5-th percentile0.14375
Q10.32675
median0.488
Q30.66875
95-th percentile0.87405
Maximum0.972
Range0.9339
Interquartile range (IQR)0.342

Descriptive statistics

Standard deviation0.22376275
Coefficient of variation (CV)0.45128006
Kurtosis-0.8695319
Mean0.49584009
Median Absolute Deviation (MAD)0.1725
Skewness0.08723791
Sum545.4241
Variance0.050069767
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.446 10
 
0.9%
0.288 7
 
0.6%
0.494 7
 
0.6%
0.552 6
 
0.5%
0.544 5
 
0.5%
0.349 5
 
0.5%
0.485 5
 
0.5%
0.235 5
 
0.5%
0.613 5
 
0.5%
0.742 5
 
0.5%
Other values (609) 1040
94.5%
ValueCountFrequency (%)
0.0381 1
0.1%
0.0499 1
0.1%
0.0557 1
0.1%
0.0605 1
0.1%
0.0628 1
0.1%
0.0666 1
0.1%
0.0694 1
0.1%
0.0753 1
0.1%
0.0765 1
0.1%
0.0789 1
0.1%
ValueCountFrequency (%)
0.972 1
0.1%
0.969 1
0.1%
0.965 1
0.1%
0.962 1
0.1%
0.961 2
0.2%
0.958 1
0.1%
0.956 1
0.1%
0.952 2
0.2%
0.95 1
0.1%
0.943 1
0.1%

Interactions

Correlations

popularitydurationmsyeardanceabilityacousticnessenergyinstrumentalnesslivenessloudnessspeechinesstempovalenceexplicit
popularity1.000-0.0640.2670.0150.186-0.1660.035-0.018-0.085-0.059-0.028-0.0280.067
durationms-0.0641.000-0.382-0.1610.004-0.0200.110-0.012-0.082-0.102-0.011-0.1700.148
year0.267-0.3821.0000.1870.220-0.207-0.031-0.025-0.1210.1580.003-0.0130.231
danceability0.015-0.1610.1871.000-0.040-0.0790.059-0.120-0.0070.256-0.0670.3600.330
acousticness0.1860.0040.220-0.0401.000-0.447-0.076-0.000-0.285-0.020-0.155-0.1580.104
energy-0.166-0.020-0.207-0.079-0.4471.000-0.0140.0900.7140.0430.1070.4200.204
instrumentalness0.0350.110-0.0310.059-0.076-0.0141.000-0.084-0.156-0.0700.009-0.1160.057
liveness-0.018-0.012-0.025-0.120-0.0000.090-0.0841.0000.0300.0110.061-0.0300.056
loudness-0.085-0.082-0.121-0.007-0.2850.714-0.1560.0301.000-0.0330.0560.3730.079
speechiness-0.059-0.1020.1580.256-0.0200.043-0.0700.011-0.0331.0000.1150.0890.372
tempo-0.028-0.0110.003-0.067-0.1550.1070.0090.0610.0560.1151.0000.0100.097
valence-0.028-0.170-0.0130.360-0.1580.420-0.116-0.0300.3730.0890.0101.0000.073
explicit0.0670.1480.2310.3300.1040.2040.0570.0560.0790.3720.0970.0731.000

Missing values

A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

idnameartistsartistidexplicitpopularitydurationmsyeargenresdanceabilityacousticnessenergyinstrumentalnesslivenessloudnessspeechinesstempovalence
03w3y8KPTfNeOKPiqUTakBhLocked out of Heaven['Bruno Mars']0du5cEVh5yTK9QJze8zA0CFalse842334782012['dance pop', 'pop']0.7260.049000.6980.0000000.3090-4.1650.0431143.9940.867
13TGRqZ0a2l1LRblBkJoaDxCall Me Maybe['Carly Rae Jepsen']6sFIWsNpZYqfjUpaCguejuFalse691934002012['canadian pop', 'dance pop', 'electropop', 'pop', 'post-teen pop']0.7830.011400.5800.0000020.1080-6.5480.0408120.0210.660
27a86XRg84qjasly9f6bPSDWe Are Young (feat. Janelle Monáe)['fun.', 'Janelle Monáe']5nCi3BB41mBaMH9gfr6Su0False702506262012['baroque pop', 'metropopolis', 'modern rock', 'pop rock']0.3780.020000.6380.0000770.0849-5.5760.0750184.0860.735
31z9kQ14XBSN0r2v6fx4IdGDiamonds['Rihanna']5pKCCKE2ajJHZ9KAiaK11HFalse672251462012['barbadian pop', 'dance pop', 'pop', 'urban contemporary']0.5640.001250.7100.0000000.1090-4.9200.046191.9720.393
43GZD6HmiNUhxXYf8Gch723Lost['Frank Ocean']2h93pZq0e7k5yf4dywlkpMTrue812340932012['hip hop', 'lgbtq+ hip hop', 'neo soul', 'pop']0.9130.027200.6030.0005030.1670-4.8920.2260123.0610.497
54Li2WHPkuyCdtmokzW2007Ni**as In Paris['JAY-Z', 'Kanye West']3nFkdlSjzX9mRTtwJOzDYBTrue802193332012['east coast hip hop', 'hip hop', 'rap']0.7890.127000.8580.0000000.3490-5.5420.3110140.0220.775
64cluDES4hQEUhmXj6TXkSoWhat Makes You Beautiful['One Direction']4AK6F7OLvEQ5QYCBNiQWHqFalse801999862012['boy band', 'pop', 'post-teen pop', 'talent show']0.7260.009000.7870.0000000.0596-2.4940.0737124.9900.888
76nek1Nin9q48AVZcWs9e9DParadise['Coldplay']4gzpq5DPGxSnKTe4SA8HAUFalse802787192012['permanent wave', 'pop']0.4490.050900.5850.0000870.0833-6.7610.0268139.6310.212
82V65y3PX4DkRhy1djlxd9pDon't You Worry Child - Radio Edit['Swedish House Mafia', 'John Martin']1h6Cn3P4NGzXbaXidqURXsFalse772128622012['dance pop', 'edm', 'electro house', 'pop', 'pop dance', 'progressive electro house']0.6120.112000.8400.0000000.1160-3.1450.0509129.0420.438
96lanRgr6wXibZr8KgzXxBlA Thousand Years['Christina Perri']7H55rcKCfwqkyDFH9wpKM6False772851202012['dance pop', 'neo mellow', 'pop', 'pop rock', 'post-teen pop']0.4210.309000.4070.0009610.1100-7.4450.0267139.0280.161
idnameartistsartistidexplicitpopularitydurationmsyeargenresdanceabilityacousticnessenergyinstrumentalnesslivenessloudnessspeechinesstempovalence
109034ZAzO78a5DAVNrYIGWcPmShirt['SZA']7tYKF4w9nC0nq9CsPZTHyPTrue811818302022['pop', 'r&b']0.8240.146000.4530.0273000.0896-9.6040.0968119.9590.552
10910T5iIrXA4p5GsubkhuBIKVUntil I Found You['Stephen Sanchez']5XKFrudbV4IiuE5WuTPRmTFalse841777202022['gen z singer-songwriter', 'pop']0.5390.727000.5080.0000000.1740-6.0500.0288101.3580.227
10920QHEIqNKsMoOY5urbzN48uMade You Look['Meghan Trainor']6JL8zeS1NmiOftqZTRgdTzFalse901342562022['dance pop', 'hip pop', 'pop']0.8380.345000.5250.0000020.0771-3.5620.0665144.9810.884
10933rWDp9tBPQR9z6U5YyRSK4Midnight Rain['Taylor Swift']06HL4z0CvFAxyc27GXpf02False831747822022['pop']0.6430.690000.3630.0000520.1150-11.7380.0767139.8650.230
10945IgjP7X4th6nMNDh4akUHbUnder The Influence['Chris Brown']7bXgB6jMjp9ATFy66eO08ZTrue891846132022['dance pop', 'r&b']0.7330.063500.6900.0000010.1050-5.5290.0427116.9920.310
10952g6tReTlM2Akp41g0HaeXNDie Hard['Kendrick Lamar', 'Blxst', 'Amanda Reifer']2YZyLoL8N0Wb9xBt1NhZWgTrue762390262022['conscious hip hop', 'hip hop', 'rap', 'west coast rap']0.7750.319000.7360.0011600.1270-8.0720.2470100.9880.362
10964pi1G1x8tl9VfdD9bL3maTBig Energy['Latto']3MdXrJWsbVzdn6fe5JYkSQTrue651725402022['pop', 'rap', 'trap queen']0.9370.045300.7930.0000000.3410-4.4310.1150106.0220.794
10973LtpKP5abr2qqjunvjlX5iDoja['Central Cee']5H4yInM5zmHqpKIoMNAx4rTrue84973922022['melodic drill']0.9110.380000.5730.0000000.4030-7.4300.2880140.0400.972
10983XOalgusokruzA5ZBA2Qcbpushin P (feat. Young Thug)['Gunna', 'Future', 'Young Thug']2hlmm7s2ICUX0LVIhVFlZQTrue741362662022['atl hip hop', 'hip hop', 'melodic rap', 'rap', 'trap']0.7730.007830.4220.0069300.1290-4.5720.187077.5020.488
10991r8ZCjfrQxoy2wVaBUbpwgThousand Miles['The Kid LAROI']2tIP7SsRs7vjIcLrU85W8JTrue771647812022['australian hip hop', 'pop']0.3760.085800.6570.0000000.0884-4.6580.076880.5650.203